﻿using Dapper;

using Persistence.abs;
using System;
using System.Collections.Generic;
using System.Linq;

namespace Persistence.mySql {
    public class CoreStockServer :AbsCoreStockServer, ICoreStockServer {
        public override List<CoreStock> getBackStock() {
            String sql = "SELECT *  FROM [Core_stock] where status<0  and TIMESTAMPDIFF(DAY,change_Time,now())>40";

            return readConn().Query<CoreStock>(sql).ToList();
        }

    }
}
